home *** CD-ROM | disk | FTP | other *** search
- Order_Date
- 8,3,12
- Ship_Date
- 8,3,32
- Invoice_No
- 6,3,53
- Cust_No
- 5,3,69
- Ship_No
- 10,4,55
- Type
- 2,4,72
- PO_No
- 20,5,50
- Tax
- 4,5,76
- Terms
- 15,6,50
- Ship_Via
- 15,7,58
- Ship_Chge
- 7,8,57
- Disc
- 3,8,71
- Sp1
- 60,12,5
- Sp2
- 60,13,5
- Item1
- 12,11,58
- Des1
- 29,14,6
- Order1
- 5,14,44
- Ship1
- 5,14,57
- Price1
- 7,14,71
- Item2
- 12,15,7
- Des2
- 30,15,25
- Order2
- 5,15,63
- Ship2
- 5,15,75
- Price2
- 7,16,8
- Item3
- 12,16,23
- Des3
- 30,16,41
- Order3
- 5,17,8
- Ship3
- 5,17,20
- Price3
- 7,17,33
- Item4
- 12,17,48
- Des4
- 30,18,6
- Order4
- 5,18,44
- Ship4
- 5,18,56
- Price4
- 7,18,69
- Item5
- 12,19,7
- Des5
- 30,19,25
- Order5
- 5,19,63
- Ship5
- 5,19,75
- Price5
- 7,20,8
- Item6
- 12,20,23
- Des6
- 30,20,41
- Order6
- 5,21,8
- Ship6
- 5,21,20
- Price6
- 7,21,33
- Item7
- 12,21,48
- Des7
- 30,22,6
- Order7
- 5,22,44
- Ship7
- 5,22,56
- Price7
- 7,22,69
- T1 :zzzz.##:(Ship1*Price1).2
- 7,23,4
- T2 :zzzz.##:(Ship2*Price2).2
- 7,23,15
- T3 :zzzz.##:(Ship3*Price3).2
- 7,23,26
- T4 :zzzz.##:(Ship4*Price4).2
- 7,23,37
- T5 :zzzz.##:(Ship5*Price5).2
- 7,23,48
- T6 :zzzz.##:(Ship6*Price6).2
- 7,23,59
- T7 :zzzz.##:(Ship7*Price7).2
- 7,23,70
- DT :z,zzz.##:(((T1+T2+T3+T4+T5+T6+T7)*Disc)/100).2
- 7,9,47
- Taxes :z,zzz.##:(((T1+T2+T3+T4+T5+T6+T7-DT)*Tax)/100).2
- 7,10,50
- Sold_To (@Cust_No,NAME,ACCOUNT_NO,NAME)
- 36,4,9
- Ads1 (@Cust_No,NAME,ACCOUNT_NO,ADDRESS1)
- 36,5,6
- Ads2 (@Cust_No,NAME,ACCOUNT_NO,ADDRESS2)
- 36,6,6
- Cty (@Cust_No,NAME,ACCOUNT_NO,CITY)
- 18,7,5
- ST (@Cust_No,NAME,ACCOUNT_NO,STATE)
- 3,7,28
- Zip (@Cust_No,NAME,ACCOUNT_NO,ZIP)
- 10,7,37
- Ship_To (@Ship_No,NAME,ACCOUNT_NO,NAME)
- 36,8,9
- Ads4 (@Ship_No,NAME,ACCOUNT_NO,ADDRESS1)
- 36,9,6
- Ads5 (@Ship_No,NAME,ACCOUNT_NO,ADDRESS2)
- 36,10,6
- Cty2 (@Ship_No,NAME,ACCOUNT_NO,CITY)
- 18,11,6
- ST2 (@Ship_No,NAME,ACCOUNT_NO,STATE)
- 3,11,30
- Zip2 (@Ship_No,NAME,ACCOUNT_NO,ZIP)
- 10,11,40
- |Order_Date Ship_Date Invoice_No Cust_No |
- |Sold_To Ship_No Type |
- |Ads1 PO_No Tax |
- |Ads2 Terms |
- |Cty ST Zip Ship_Via |
- |Ship_To Ship_Chge Disc |
- |Ads4 DT |
- |Ads5 Taxes |
- |Cty2 ST2 Zip2 Item1 |
- |Sp1 |
- |Sp2 |
- |Des1 Order1 Ship1 Price1 |
- |Item2 Des2 Order2 Ship2 |
- |Price2 Item3 Des3 |
- |Order3 Ship3 Price3 Item4 |
- |Des4 Order4 Ship4 Price4 |
- |Item5 Des5 Order5 Ship5 |
- |Price5 Item6 Des6 |
- |Order6 Ship6 Price6 Item7 |
- |Des7 Order7 Ship7 Price7 |
- |T1 T2 T3 T4 T5 T6 T7|
-